NitroFlare Cool way to create Data Models and Relationships in Excel

Discussion in 'E-Books & Tutorials' started by kocogi, Dec 25, 2015.

  1. kocogi

    kocogi Active Member

    Joined:
    May 29, 2012
    Messages:
    17,043
    Likes Received:
    12
    Trophy Points:
    38
    [​IMG]
    Cool way to create Data Models and Relationships in Excel
    WEBRip | MP4/AVC, ~555 kb/s | 1280 x 720 | English: AAC, 63.8 kb/s (2 ch), 44.1 KHz | 426 MB
    Genre: Office Productivity / Microsoft | Language: English | +Project Files



    "Develop your skills and knowledge on how to create a data models for your enterprise "

    This course enables you to develop your own data models to gather accurate, complete and timely reports from your enterprise system. Whether you are new to Excel or an advanced user, Grey Campus Power course will cover what you need to know to become a Power BI User.
    In this course, we will cover the various topics about the power BI which includes:

    How to publish Excel Spreadsheets using SharePoint
    ER diagrams
    Designing a layout for Excel based data model
    How to use a Power Query to create data models
    Power Pivot, design and manage the newly built data model
    Develop Interactive Dashboards using Power Views

    Each and every topic mentioned above are explained in detail in the Hands-on videos. Excercises and datasets included in this course are useful to practice and implement the concepts learned in this course.
    This course is is intended for the analysts and business users who are willing to explore the Power BI tools present in Microsoft Excel 2013. This training is best suited for all business professionals: data analysts, developers, IT professionals, project leads, and project managers.

    What are the requirements?

    Some knowledge of basic word processing, computing, and spreadsheets
    Familiarity with the Microsoft Office work environment

    What am I going to get from this course?

    Over 14 lectures and 2 hours of content!
    Build a report using Power View
    Hide columns, sort, change data types, and filter
    Create calculated fields and calculated columns
    Add a calculated field from the pivot table
    Develop Interactive Dashboards using Power Views
    Manage data sources and queries

    What is the target audience?

    Anyone who uses MS Excel as part of their job or profession can choose this course
    There is no eligibility Criteria

    Curriculum
    Section 1: Course Introduction
    Lecture 1 Course Introduction 03:26
    Section 2: Publishing Excel Spreadsheets using SharePoint
    Lecture 2 Publishing Excel Spreadsheets using SharePoint 10:13
    Section 3: Study the existing ER diagram, metadata of the existing database schema
    Lecture 3 Study the existing ER diagram, metadata of the existing database schema 08:38
    Section 4: Identify cardinality and design a layout for Excel based data model
    Lecture 4 Identify cardinality and design a layout for Excel based data model 19:15
    Section 5: Using Power Query to create data models
    Lecture 5 Using Power Query to create data models 13:20
    Section 6: Using Power Pivot, design and manage the newly built data model
    Lecture 6 Using Power Pivot, design and manage the newly built data model 08:04
    Section 7: Define entity relationships and check cardinality
    Lecture 7 Define entity relationships and check cardinality 09:20
    Section 8: Develop Interactive Dashboards using Power Views
    Lecture 8 Develop Interactive Dashboards using Power Views 09:42
    Section 9: Using Timelines and Tab views for Dashboards
    Lecture 9 Using Timelines and Tab views for Dashboards Part 1 16:16
    Lecture 10 Using Timelines and Tab views for Dashboards Part 2 12:13
    Section 10: Additional Material
    Lecture 11 Additional Material Text
    Section 11: Exercises
    Lecture 12 Exercises Text
    Section 12: Mock Test
    Quiz 1 Mock Test 20 questions
    Section 13: Course Conclusion
    Lecture 13 Review Appreciated Text
    Lecture 14 Quick Bonus for You! Text
    Buy Premium From My Links To Get Resumable Support,Max Speed & Support Me
    Code:
    Download ( NitroFlare )
    http://nitroflare.com/view/9DAFF4FC0E1724F/wfz7v.C.w.t.c.D.M.a.R.i.E.rar
    
    
    
    
    
    
    
    Oboom
    https://www.xxxxxxxx/PJ1MWPZB/wfz7v.C.w.t.c.D.M.a.R.i.E.rar
     

Share This Page