Course Description: This course involves the creation of advanced Pivot Tables in Microsoft Excel® using the add-in program, Power Pivot. Data analysis in Excel is limited to using data list or table sources constructed as flat-file databases. With Excel being a spreadsheet program and not a relational database, trying to connect to multiple data sources […]
Course Description: This course involves the creation of exploration, analysis, and reporting of data insights and trends using the Microsoft Power BI® software. Power BI was built to connect to a wide range of data sources and allows users to quickly create visualizations of connected data to gain such insights, trends, and reports. Power BI's […]