Analyzing Data with Excel

About this course
The main purpose of the course is to give students the ability to add BI techniques to Excel data analysis. The course goes beyond the capabilities of tables and charts and uses Pivot Charts, the Excel Data Model, and Power BI.
Audience This course is intended for students who are experienced with analyzing data with Excel and who wish to add BI techniques. The course will likely be attended by SQL Server report creators who are interested in alternative methods of presenting data. Prerequisites Before attending this course, students must have:
      • Basic knowledge of the Microsoft Windows operating system and its core functionality.
      • Working knowledge of relational databases.
      • Extensive knowledge of Excel spreadsheets including formulas, charts, filtering, sorting, and sub-totals.
      • Basic knowledge of data analytics equivalent to having attended course 10994.
Objective After completing this course, students will be able to:
      • Explore and extend a classic Excel dashboard.
      • Explore and extend an Excel data model.
      • Pre-format and import a .CSV file.
      • Import data from a SQL Server database
      • Import data from a report.
      • Create measures using advanced DAX functions.
      • Create data visualizations in Excel.
      • Create a Power BI dashboard with Excel.
https://www.liit.com/course/analyzing-data-with-excel/?feed_id=79724&_unique_id=63d8c17320b17&Analyzing%20Data%20with%20Excel

Comments

Post a Comment

Popular posts from this blog

CCSA & CCSE

Description Of The Program: 1) CCSA - Check Point Certified Security Administrator:- CCSA is a foundation level certification that validates a candidates ability to configure and manage fundamental implementations of Check Point's flagship product. 2) CCSE - Check Point Certified Security Expert:- CCSE certification is recognized as the industry standard for Internet security certifications. CCSEs possess the knowledge and expertise to configure VPN-1/FireWall-1 as an Internet security solution and virtual private network (VPN) that securely connects corporate offices and remote workers, protecting information exchange and granting access to network resources. CCSE training and testing builds on CCSA training by including an in depth study of encryption technologies and how to implement site-to-site and remote access VPNs. Description of Unique Features Of The Program: LasComp Institute of IT (LIIT) provides professional job-oriented certified training with small classes
Read more

Accounting Certification

Description Of The Program: This program will begin as an introduction to accounting and it will cover advanced accounting functions and cost accounting. Financial concepts such as the accounting equation, definitions of assets, liabilities and equities, as well as basic financial statements will be discussed. An added component to relate this basic accounting information to the real world will include practical concepts used in computerized accounting. Description of Unique Features Of The Program: This program required 160 hrs class time and 160 lab works. https://www.liit.com/course/accounting-certification/?feed_id=86956&_unique_id=63e864e86ebd5&Accounting%20Certification
Read more

AWS Solutions Architect - Professional

In this course, you will build on concepts introduced in Architecting on AWS. You will learn how to build complex solutions that incorporate data services, governance, and security on the AWS platform. You will also learn about specialized AWS services, including AWS Direct Connect and AWS Storage Gateway, that support hybrid architecture, and you will learn about best practices for building scalable, elastic, secure, and highly available applications on AWS. Intended Audience This course is intended for: Individuals who are experienced with designing scalable and elastic applications on the AWS platform Course Objectives In this course, you will learn to: Apply the AWS Well-Architected Framework Manage multiple AWS accounts for your organization Connect an on-premises data center to the AWS Cloud Discuss billing implications of connecting multi-region VPCs Move large data from an on-premises data center to AWS Design large data sto
Read more