{"id":15,"date":"2024-05-06T10:48:37","date_gmt":"2024-05-06T14:48:37","guid":{"rendered":"https:\/\/community.mis.temple.edu\/linhnhoang\/blog\/points\/excel-working-together-with-power-query-and-power-pivot\/"},"modified":"2024-05-06T10:48:37","modified_gmt":"2024-05-06T14:48:37","slug":"excel-working-together-with-power-query-and-power-pivot","status":"publish","type":"points","link":"https:\/\/community.mis.temple.edu\/linhnhoang\/points\/excel-working-together-with-power-query-and-power-pivot\/","title":{"rendered":"Excel: Working Together with Power Query and Power Pivot"},"content":{"rendered":"<p>This course equips me with the skills to clean efficiently, transform, and model data for analysis. With a focus on practical applications and real-world scenarios, I gain proficiency in creating dynamic reports, visualizations, and dashboards, ultimately driving impactful business outcomes through data-driven strategies I learn how to create relationships between tables, define calculations using DAX (Data Analysis Expressions), and build sophisticated data models to analyze large datasets. I got to perform advanced calculations beyond traditional Excel formulas&#8217; capabilities. DAX functions allow for complex calculations like time intelligence, ranking, and statistical analysis.<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"author":29948,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-15","points","type-points","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/community.mis.temple.edu\/linhnhoang\/wp-json\/wp\/v2\/points\/15","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/community.mis.temple.edu\/linhnhoang\/wp-json\/wp\/v2\/points"}],"about":[{"href":"https:\/\/community.mis.temple.edu\/linhnhoang\/wp-json\/wp\/v2\/types\/points"}],"author":[{"embeddable":true,"href":"https:\/\/community.mis.temple.edu\/linhnhoang\/wp-json\/wp\/v2\/users\/29948"}],"replies":[{"embeddable":true,"href":"https:\/\/community.mis.temple.edu\/linhnhoang\/wp-json\/wp\/v2\/comments?post=15"}],"version-history":[{"count":0,"href":"https:\/\/community.mis.temple.edu\/linhnhoang\/wp-json\/wp\/v2\/points\/15\/revisions"}],"wp:attachment":[{"href":"https:\/\/community.mis.temple.edu\/linhnhoang\/wp-json\/wp\/v2\/media?parent=15"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}