Data analysis is the process of gleaning insights from data to help inform better business decisions. A data analyst collects, cleans, sorts, and interprets data sets in order to answer questions or suggest solutions. Skilled data analysts are some of the most sought-after professionals in the world. It’s a field you can grow into and there are several areas of specialization.
Call 1-888-922-1132 to discuss your learning path.
This two-day course provides students with the knowledge and skills to analyze data with Power BI.
No matter where your data comes from – whether it’s a small or very large data set – you can connect, clean, analyze, and share your data faster using Power Query. This course guides you through the essentials of data extraction and transformation, teaching you to seamlessly integrate data from multiple sources and transform the time-consuming chore of data preparation into an efficient, automated process.
This course gives you the skills to turn raw data into striking visual stories. We’ll show you how to find the story in the data, and how to convert the data into graphics. You will explore different infographic formats and practice developing the content from start to finish. You’ll also explore typography, and choose typefaces that look great while helping you organize the presentation of your data.
The ability to write well has always been a necessary skill for professionals. But now with everyone facing compressed timelines and information overload it is more important than ever. In this workshop, students learn how to make all their professional communications more concise, polished and precise.
This one-day course teaches you the basics of work books and work sheets. You will learn how to enter and format data, text, and formulas; how to use pre-defined functions for basic calculations; and how to avoid errors. You will also learn how to organize and manage lists and tables (including sorting, filtering, and analyzing).
With this intermediate Excel course you’ll really ramp up your productivity. Using robust formulas and surprisingly simple techniques, you will be slicing and dicing to discover the power of data analysis. You’ll create Pivot Tables, build fully functional financial dashboards, and complete relevant exercises. At this level, Excel is an eye-opener.
Pivot Tables – one of the most powerful features of Excel – allow large amounts of data to be summarized and analyzed with just a few mouse clicks, and without any formulas. You'll be able to drag and drop fields directly into a Pivot Table to change your report layout to whatever you want, whenever you want. This one-day workshop culminates in building a sophisticated, yet uncomplicated dashboard that communicates financial information with power and ease you never thought possible.