The only course you need to launch your career as a Data Professional! Learn to master Excel's built-in power tools, including Power Query, Power Pivot Tables, Data Modeling, the DAX formula language, and so much more. Become a Business Intelligence Analyst and get hired.
- Become a top 10% Business Intelligence Analyst or Data Analyst to enhance your skillset and career opportunities
- Build an end-to-end Business Intelligence solution for a fictional surf shop, including dozens of powerful KPIs that provide deep insight into business performance
- Use Power Query to pull external datasets into Excel, and transform them into whatever shape is needed for data analysis
- Master the art and science of Data Modeling in Excel, connecting relational datasets from Power Query so they can be analyzed together
- Build 'Power' Pivot Tables to rapidly extract insights from the Excel Data Model, whether your data tables have 10 rows or 10 million
- Proficiently apply the DAX formula language, to inject sophisticated calculations and KPIs into Pivot Tables
- Polish calculations into professional presentations, with data visualization tools like Pivot Charts and conditional formatting
- Use Excel's powerful charting engine to tell the story of your data with attractive data visualizations
- Learn how to build Excel formulas for data analysis, data science, data entry, and everyday office use
- Leverage Slicers and Timelines to engineer dynamic dashboards that maximize the amount of information you can present on a single screen
- Learn how to use Microsoft Excel to supplement your Power BI skills
- Loads of exercises to practice and perfect your skills
- Learn why Excel is one of the most popular pieces of software across all industries
- Master Excel's built-in 'power' tools and see how they're nearly identical to those found in Microsoft's flagship Business Intelligence tool, Power BI
