BI348 — Big Data Business Analytics with Microsoft Power Tools
BI 348 - Big Data Business Analytics with Microsoft Power Tools BI 348 - Big Data Business Analytics with Microsoft Power Tools 5 Credits Students will use Microsoft’s new Power Tools (Excel Power Pivot, Power Query and Power BI Desktop) to convert real world large data sets into useful information for business decision making. In addition to learning some standard Excel features, students will learn, in depth, how to use the computer languages DAX and M Code to clean, transform and load data, as well as how to convert the loaded data into useful information for reporting, visualizing, analytics and dashboarding. 0 (or MATH& 146) and BUSN 218 min 2.0 Program Admission Required Yes Admitted Program BAS - BUSN Course Note Acceptance to BAS in Applied Management required. Fees CF Quarters Typically pring Evening, Online Designed to Serve Students pursuing the BAS in Global Trade & Logistics Active Date 20220308T16:47:31 Grading Basis Decimal Grade Class Limit 24 Lecture 55 Total Degree Distributions: ProfTech Course Yes Restricted Elective Yes Course Outline Overview of all tools and concepts in the class. Define Data Analysis and Business Intelligence. Define Data Analysis, Business Intelligence and Data Warehousing Terms and concepts. Use Excel Spreadsheet Formulas and Functions for ETL and creating information solutions. Use Standard PivotTables for creating information solutions. Use Power Query to extract, transform and load data to the Excel Worksheet, PowerPivot Data Mode
Prerequisites: BUSN210, BUSN218