Microsoft SQL Server 2019 - Introduction to Data Analysis Training Course

Course Description This course will discuss the responsibilities and functions of a data analyst. Which includes the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI. The course will also show how to access and process data from a range of data sources including both relational and non-relational data. This course will also explore how to implement proper security standards and policies across the Power BI spectrum including datasets and groups. The course will also discuss how to manage and deploy reports and dashboards for sharing and content distribution. This course will show how to build paginated reports within the Power BI service and publish them to a workspace for inclusion within Power BI. Power BI is a member of the Power Platform. Power Apps is another component that enables everyone to build and use apps that connect to business data. This course will show you how to use the Power Apps visual to pass context-aware data to a canvas app, which updates in real-time as you make changes to your report. This will allow your app users to derive business insights and take actions from right within their Power BI reports and dashboards. This course will also include information on basic T-SQL query development. Ingest, clean, and transform data Model data for performance and scalability Design and create reports for data analysis Apply and perform advanced report analytics Manage and share report assets Create paginated reports in Power BI Embed Power Apps into Power BI Understand the similarities and differences between Transact-SQL and other computer languages. Write SELECT queries Query multiple tables Sort and filter data Instructor: James Ring-HowellCourse Video Content: 13 Hours 58 MinutesTest Questions: 75 Course Content Module 1 - Query Tools1.1 Course Introduction1.2 Intro to Management Studio1.3 Intro to command-line query toolsModule 2 - Introduction to T-SQL Querying2.1 Introducing T-SQL2.2 Understanding Sets2.3 Understanding the Logical Order of Operations in SELECT statementsModule 3 - Basic SELECT Queries3.1 Writing Simple SELECT Statements3.2 Eliminate Duplicates with DISTINCT3.3 Using Column and Table Aliases3.4 Write Simple CASE ExpressionsModule 4 - Querying Multiple Tables4.1 Understanding Joins4.2 Querying with Inner Joins4.3 Querying with Outer Joins4.4 Querying with Cross Joins and Self JoinsModule 5 - Sorting and Filtering Data5.1 Sorting Data5.2 Filtering Data with Predicates5.3 Filtering with the TOP and OFFSET-FETCH5.4 Working with Unknown ValuesModule 6 - Introduction to Business Intelligence and Data Modeling6.1 Introduction to Business Intelligence6.2 The Microsoft Business Intelligence Platform6.3 Exploring a Data Warehouse6.4 Exploring a Data ModelModule 7 - Prepare Data7.1 Introduction to Power BI7.2 Get data from various data sources7.3 Preview source dataModule 8 - Clean, Transform, and Load Data8.1 Data Transformation Intro8.2 Transformation Example 18.3 Transformation Example 28.4 Transformation Example 38.5 Transformation Example 48.6 Transformation Example 58.7 Transformation Example 6Module 9 - Design a Data Model9.1 Introduction to Data Modeling9.2 Model Relationships9.3 Table Configuration9.4 Model interface9.5 Quick Measures9.6 Many-to-many relationships9.7 Row-level securityModule 10 - Create Model Calculations using DAX10.1 DAX context10.2 Calculated Tables10.3 Calculated Columns10.4 Managing Date Tables10.5 Measures10.6 Filter Manipulation10.7 Time IntelligenceModule 11 - Create Reports11.1 Basic Report Creation11.2 Example Page 111.3 Example Page 211.4 Example Page 311.5 Report Publishing11.6 Enhancing Reports11.7 Drill-Through Pages11.8 Conditional Formatting11.9 Buttons and BookmarksModule 12 - Create Dashboards12.1 Dashboard Basics12.2 Real Time Dashboards12.3 Enhanced DashboardsModule 13 - Create Paginated Reports13.1 Introduction to Power BI Report Builder13.2 Report Layouts13.3 Report Data13.4 Report TablesModule 14 - Perform Advanced Analytics14.1 Introduction to Advanced Analytics14.2 Scatter Chart14.3 Forecast14.4 Decomposition Tree14.5 Key InfluencersModule 15 - Create and Manage Workspaces15.1 Introduction to Workspaces15.2 Working with Workspaces and the PortalModule 16 - Create Power App Visuals16.1 Introduction to Power Apps Visual16.2 Creating the App16.3 Basic Power Apps Concepts16.4 Refreshing the ReportModule 17 - Analysis Services and Power BI17.1 Introduction to Analysis Services17.2 Connecting with Multidimensional Models17.3 Premium Workspaces and Analysis Services17.4 Course Wrap Up LEARN365 Courses Include 12 Months Unlimited Online Access to: Expert Instructor-Led Training: Learn 365 uses only the industry's finest instructors in the IT industry. They have a minimum of 15 years real-world experience and are subject matter experts in their fields. Unlike a live class, you can fast-forward, repeat or rewind all your lectures. This c