Pivot tables are really very easy to create, but very powerful. By using Excel pivot tables, one can get very interesting and valuable business intelligence from your data in very little time. This short session aims to give you the techniques to use this valuable Excel tool creatively. It is enough time to learn a lot about Excel Pivot Tables, but there is very little time for other questions.
Preparing for Digital Transformation Organizations today must keep pace with changing technology to stay abreast of the market demand. Keeping pace means a transformation of the entire organization into the digital age. This workshop presents the challenges, benefits, and pitfalls of digital transformation and how it will affect you, and how you can be better prepared and positioned for the upcoming digital transformation. The goal of this course is to enable you to become knowledgeable about the technologies behind a digital transformation in your organization and the driving forces compelling such a transformation. You will learn how to become engaged in the processes of transforming your organization digitally to meet with the growing demands of customers and clients What you will Learn Describe the impact that digital is making on the economy and on customer expectations Examine the nature and drivers of the digital transformation Evaluate new technologies such as Blockchain, Big Data, Artificial Intelligence, and other technologies and see how they work to bring about digital transformation Assess the impact of digital technologies on the current roles and positions in the organization Discuss both the demand that customers have for digital technologies and the impact the digital technologies have on the customer and its relationship with the organization Recognize the new technology trends in the digital transformation and what they mean to the future of the organization Identify how digital transformation will affect all roles and how to be prepared for the upcoming and continuing digital transformation Foundation Concepts Digital transformation versus automation Driving forces behind the digital transformation Learning from digital transformation successes Digital Transformation and Customer Orientation The Digital Customer Customer touch points and the customer journey Omnichannel concept Transform to the customer Digital Technologies and the Organization Relationship Management Big Data: The Basis for it All The Human Factor in Digital Transformations Risks of Digital Transformation Technology Trends Data and Business Analytics Other Major Trends Preview of Coming Attractions Pathway to Digital Transformation
Internet of Things training course description A concise overview course covering The Internet of Things and the technologies involved. Particular emphasis is placed on the high level architecture of IoT and the benefits achievable. What will you learn Describe the structure of the IoT List the technologies involved in IoT. Explain how IoT works. Internet of Things training course details Who will benefit: Non-technical staff working with IoT. Prerequisites: None. Duration 1 day Internet of Things training course contents What is IoT The Internet, what is IoT? IoT and M2M, IoT technologies, IoT architecture. Wired and wireless communication. IoT applications; Smart houses, smart cities, smart cars, wearable, environment, other domain specific IoTs. IoT architecture Physical objects, virtual objects, cloud computing, data capture, communications. Big data. Components Hardware, sensors, actuators, chips, firmware, embedded systems. Open source platforms. Power options: Battery, solar, PoE. IoT communication RF, ZigBee, Bluetooth, Bluetooth LE, RFID, WiFi, 802.11ah, mobile technologies. Wired. Arduino (as an example) Microcontrollers, the platform, development, Arduino software, reading from sensors, I2C, SPI. Arduino and the Internet, HTTP, WiFi, GSM. The cloud and IoT: Pachube, nimbits, ThingSpeak Security in IoT Authentication, Encryption, secure booting, firewalls.
Data analysis translates numbers and data into information that can be used to solve problems or track business performance. Data analysis produces graphs, charts, tables and reports. Data analysis is in high demand across all sectors, such as finance, consulting, manufacturing, pharmaceuticals, government and education. The ability to pay attention to detail, communicate well and be highly organised are essential skills for data analysts. They not only need to understand the data but be able to provide insight and analysis through clear visual, written and verbal communication. This course provides the knowledge and skills to help you hone your data analysis skills.
Develop true Digital Marketing Strategy expertise with DMI Specialist. Learn digital communications, analytics, marketing automation and budget & strategy formulation from Industry Skills Experts. Course Overview This dynamic online Diploma in Digital Strategy & Planning course covering topics in digital communications, analytics, marketing automation and budget & strategy formulation giving you the skills, know-how, strategy and techniques to be that change. Here is power. The power to influence. To speak to billions of people. Specialization is for when you don’t just want to play the digital marketing game anymore, you want to drive it. To change it. the DMI SPECIALIST online Digital Strategy and Planning certification is perfect for you to become an online digital marketer. Become a member and connect to the industry and white-hot opportunities. Here is power. The power to influence. To speak to billions of people. What’s New? Develop true Digital Marketing Strategy expertise with DMI Specialist. Learn digital communications, analytics, marketing automation and budget & strategy formulation from Industry Skills Experts. Learn every aspect of Digital Marketing Strategy across 9 modules of interactive learning to give you a highly relevant and deep knowledge of digital strategy, all wrapped up with the world’s most recognized digital marketing certification on completion. Program learning outcomes and content: WHAT WILL I LEARN? We give you the thinking and tools to become a leading player on the digital stage. Create powerful and dynamic digital strategy. See it manifest into real world, business-changing action. The modules are building blocks – of knowledge, of your vision, of the leading Certified Digital Marketing Specialist – Digital Strategy & Planning that is you. Here is what you need to know. Course Content: Introduction: We bring science to thought. We have created the 3i Framework which is designed to help you select the best digital strategy for your organisation and make it happen. The 3i is smart and rigorous. It’s transformative. And you shall be impressed. This module introduces this nifty piece of brainwork. Later modules expand on it. • The fundamental concepts underpinning the DMI 3i Methodology. • The how-to’s of business strategy development. • Key components in an effective digital strategy. • Strategic management, a long-sighted look at lasting, growing success Traditional Communications: In this model, we explore how the marketing classics still anchor any campaign – yet the contemporary digital campaign is a far more fantastical vessel. We look deep into how our tech is changing the consumer experience, and how we must respond. Digital Communications: We are living through extraordinary times. The opportunities are as big, sprawling and diverse as the World Wide Web. The challenge too is bigger. Markets are sophisticated and fragmented. Now, more than ever, thy most know thy consumer (and thy digital channels). Here we look at: the fundamentals of digital communications planning, improving ROI, understanding your audience. Where can they be found? How to engage them? Budgeting for your digital strategy and effective resources reviewing, measuring, and analysing your digital strategy. Digital Channels: Facebook, Linkedin, Instagram, Twitter, Snapchat and so on. They multiply and they proliferate. Yet in this great distraction and fragmentation, there is also great opportunity. This module covers: inbound and outbound strategies, cross media planning, the digital channel mix, and mobile marketing social media marketing. Content marketing that is relevant, timely and riveting the what, how and why of search engine marketing email marketing, affiliate marketing, and marketing automation display and video advertising best practice. Because we have eyes to see. Marketing Automation: Automation doesn’t beat inspiration but it sure makes a marketeer’s life easier and more exciting. Here is superpower, working quieting and perfectly under your orders, night and day. See how smart businesses are sharpening their edge with CRM software for better sales enablement, lead nurturing and way more. Budget & Resourcing: Money makes marketing go round. But value is where it’s at. This model goes deep on how to hit max ROI for any given budget. Then some consideration for that other precious resource, human talent. Explore: • Key factors to consider when planning a marketing budget. • Setting that marketing budget. • How to monitor and optimize a budget during campaign, execution. • The human element. • Recruit, train and keep top people. Big Data & Analytics: The Big Data & Analytics module will provide you with a broad understanding of Big Data, Advanced Analytics and Artificial Intelligence. You will learn the fundamental frameworks and understand how cutting-edge analytics tools are being used to help businesses succeed wildly. Digital Leadership: We are living in extraordinary times, which call for extraordinary leaders. That means you. You shall lead the transition from the remnants of traditional marketing and into the brave, new digital marketing world which you are helping to invent. And you shall lead with razor-sharp thought and strategy. You shall take your brand and your organisation to places yet undreamed of. Strategy Formulation & Plan: By now, you’ll have come a long way. You are (almost) ready to go forth, carve out new and unexplored neural pathways and digital markets. You are standing on the very edge of the leading-edge, and you are just about ready to spread those new digital super-wings and soar. But first, the ultimate strategy module; the ultimate in strategy. DURATION 8-10 Weeks WHATS INCLUDED Course Material Case Study Experienced Lecturer Refreshments Certificate
This advanced certification drills deep into the latest thinking to develop true digital marketing expertise. Course Overview This advanced certification drills deep into the latest thinking to develop true digital marketing expertise. Learn about Digital Strategy, CX, Search Marketing, Social Media, Leadership and more. Get world class, knowledge and insight: DMI EXPERT is our postgraduate level 140-hour course with an advanced, professional certification. It delivers breadth and depth of understanding of digital marketing and provides the learner with the digital and research skills to work at a management or strategic level. This certification is credit rated at level 11 on the Scottish Credit and Qualifications Framework and awarded 120 credit points by the SQA (Scottish Qualifications Authority), which is comparable to a postgraduate diploma awarded by a UK university. Program learning outcomes and content: What Will I Learn? We give you the thinking and tools to become a leading player on the digital stage. Create powerful and dynamic digital strategy, and access modern, career-defining training covering all key digital marketing disciplines. Course Content: Social Media Marketing: Learn how to create engaging content on social media and how to plan, execute, optimize and report on social media marketing campaigns across the key social platforms. • Social Research • Social Content • Facebook, Instagram, Pinterest • Twitter • LinkedIn • YouTube & Social Video • Social Apps • Social Commerce & Affiliate Marketing • Social Customer Service • Social Strategy Strategy and Planning: Gain all the key skills and practices associated with planning a successful digital strategy. Everything from digital channels, marketing automation, budgeting, analytics and digital leadership. • Digital Communications v Traditional Communications • Marketing automation and CRM • Budget and Resourcing • Big Data & Analytics • Strategy Formulation and Plan • Digital Communications & Channels • Omnichannel tactics CX, eCommerce and CRO: Learn the key concepts underpinning website optimization, conversion rate optimization and effective e-commerce for every business requirement. Build highly effective user experiences for your customers. • Website Optimization • UX Research & Design • E-Commerce Strategy • Applied E-Commerce • Graphic Design Essentials for Marketers Search and Digital Channels: Plan, implement, refine and report on search marketing campaigns. Drive traffic across all digital channels. Taught directly by Neil Patel and DMI’s experts, you’ll gain knowledge from people who actually use these tactics in the field. • SEO Setup & Content • SEO Workshop • Paid Search & Display Advertising • Measurement with Google Analytics • Email Marketing Strategy • Applied Email Marketing • SEO for ecommerce Digital Selling: Recognize the value of social selling and incorporate digital techniques to better engage with customers and prospects to drive increased conversion rates. • Fundamentals of Social Selling • Finding & Targeting Prospects • Attracting Customers • Closing & Retaining • Increasing Engagement Essential Skills: Gain all the essential skills all marketers, professionals and business leaders need to work effectively, productively and professionally in a collaborative business environment. • Project Planning • Creativity Skills • Personal Skills • Working With Others Leadership and Management: Develop practical skills and techniques that you can use to think strategically, build effective teams, deal with conflict and crisis and persuade and influence others. • Thinking Strategically • Building Effective Teams • Dealing with Conflicts and Crises • Persuading and Influencing DURATION 52 Weeks WHATS INCLUDED Course Material Case Study Experienced Lecturer Refreshments Certificate
This course is designed for students who already have foundational knowledge and skills in Excel and who wish to perform robust and advanced data and statistical analysis with Microsoft Excel using PivotTables, use tools such as Power Pivot and the Data Analysis ToolPak to analyze data and visualize data and insights using advanced visualizations in charts and dashboards in Excel.